Flash Fill Does Not Work 🤬🤬- How to Enable it and get Correct Results

Поделиться
HTML-код
  • Опубликовано: 5 дек 2024

Комментарии • 10

  • @EXCELWIZARDINMINUTES
    @EXCELWIZARDINMINUTES  Год назад +1

    Learn how to fix the common problems related to Flash Fill - Enable it, give it more examples, etc...😊

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  4 месяца назад

      There is an add in called chatgpt for excel. Try it. It has a feature to autofill data but it costs money.

  • @suethatswho
    @suethatswho 3 месяца назад +1

    I had a pattern that worked but then stopped working when you type a similar word out (like Work and Working). When I realized the issue I deleted the instance that messed it up (Working) but it won't ever work the same again in the same sheet. Is there a way to reset the column to identify the original pattern again? Also for some reason Cntl+E never worked for me.

    • @suethatswho
      @suethatswho 3 месяца назад +1

      I was able to fix it by deleting that cell (the one with the word that flashfill stopped working for) and inserting a fresh cell to start that cell over. Flashfill for that "broken" word started working again- AND it prompted me to refill all of the data that I had deleted, so I didnt have to retype it. YAY

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  3 месяца назад

      It seems that u went on a rollercoster ride 🤣🤣 full of adrenaline hehe

    • @suethatswho
      @suethatswho 2 месяца назад

      @@EXCELWIZARDINMINUTES lolol youre right, after reading that again im cracking up

  • @razanmagar7692
    @razanmagar7692 4 месяца назад

    There is no flash fill option in ms excel 2007😢

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  3 месяца назад

      yeah it got introduced in 2013. You might have to upgrade. Trust me, it s worth it!

  • @bopkakayht
    @bopkakayht 4 месяца назад

    none of the methods work. there is a pattern because it works within a different worksheet. I guess excel is having a brain-fart moment... 😫😫

    • @EXCELWIZARDINMINUTES
      @EXCELWIZARDINMINUTES  4 месяца назад

      @bopkakayht u might have some pattern that excel intelligence doesnt recognise😅